In [43]:
import pandas as pd
import numpy as np
import matplotlib.pyplot as plt
%matplotlib inline

In [104]:
app = pd.read_pickle('/Users/krystal/Desktop/app_clean.p')
app.head()


Out[104]:
app category comment 1 comment 2 comment 3 current rating current reviews description link multiple devices ... overall rating overall reviews price rate 1 rate 2 rate 3 seller user 1 user 2 user 3
0 Kindle – Read eBooks, Magazines & Textbooks Books Please focus on reading and listening experien... I can't believe they added a clock in the last... You guys did an amazing job updating it and co... 2.65152 66 Turn your iPhone or iPad into a Kindle with th... https://itunes.apple.com/us/app/kindle-read-eb... Y ... 3.5 245670 Free 2 1 5 AMZN Mobile LLC LambdaExpression Lorring Prellvis
1 Audible – audio books, original series & podcasts Books It's very enjoyable to be able to listen to a ... Works great 99% of the time. When it didn't, t... Audiobooks are a little bit expensive, but I l... 4.65113 1995 Welcome to Audible. We’re an Amazon company, a... https://itunes.apple.com/us/app/audible-audio-... Y ... 4 100917 Free 3 5 5 Audible, Inc. Smuckitelly Scorchedterra vtalbot
2 Wattpad - Free Books and eBook Reader Books I am absolutely *in love* with Wattpad. Not on... I love this app sooo much I won't be able to l... I love wattpad! I really do! It's my favorite ... 4.59425 313 Discover Wattpad:At Wattpad, we’re connecting ... https://itunes.apple.com/us/app/wattpad-free-b... Y ... 4.5 236764 Free 3 4 5 Wattpad Corp dg2017xx RedPandaWorld Kajdisksn
3 NOOK - Read Books, Magazines, Newspapers & Comics Books I would give it 5 stars if the App would put t... Glad to have Nook on my iPad but wish maneuver... I love reading books electronically. Having un... 4.33955 1072 Get the FREE NOOK Reading App for your iPad, i... https://itunes.apple.com/us/app/nook-read-book... Y ... 4 55593 Free 4 3 3 Barnes&Noble Morgan737364737 Too old to tap Rstocky7
4 HOOKED - Chat Stories Books Keeps you on the edge of your seat. If you lov... It's a great app and I love the chills (even i... I just got through the first three parter and ... 4.54263 129 HOOKED lets you read amazing chat stories FREE... https://itunes.apple.com/us/app/hooked-chat-st... Y ... 4.5 28004 Free 4 2 4 Telepathic Inc. 100% Honest Feedback Abbidon Gangrel_Bloodfang

5 rows × 22 columns


In [107]:
app = app.drop_duplicates()
app


Out[107]:
app category comment 1 comment 2 comment 3 current rating current reviews description link multiple devices ... overall rating overall reviews price rate 1 rate 2 rate 3 seller user 1 user 2 user 3
0 Kindle – Read eBooks, Magazines & Textbooks Books Please focus on reading and listening experien... I can't believe they added a clock in the last... You guys did an amazing job updating it and co... 2.65152 66 Turn your iPhone or iPad into a Kindle with th... https://itunes.apple.com/us/app/kindle-read-eb... Y ... 3.5 245670 Free 2 1 5 AMZN Mobile LLC LambdaExpression Lorring Prellvis
1 Audible – audio books, original series & podcasts Books It's very enjoyable to be able to listen to a ... Works great 99% of the time. When it didn't, t... Audiobooks are a little bit expensive, but I l... 4.65113 1995 Welcome to Audible. We’re an Amazon company, a... https://itunes.apple.com/us/app/audible-audio-... Y ... 4 100917 Free 3 5 5 Audible, Inc. Smuckitelly Scorchedterra vtalbot
2 Wattpad - Free Books and eBook Reader Books I am absolutely *in love* with Wattpad. Not on... I love this app sooo much I won't be able to l... I love wattpad! I really do! It's my favorite ... 4.59425 313 Discover Wattpad:At Wattpad, we’re connecting ... https://itunes.apple.com/us/app/wattpad-free-b... Y ... 4.5 236764 Free 3 4 5 Wattpad Corp dg2017xx RedPandaWorld Kajdisksn
3 NOOK - Read Books, Magazines, Newspapers & Comics Books I would give it 5 stars if the App would put t... Glad to have Nook on my iPad but wish maneuver... I love reading books electronically. Having un... 4.33955 1072 Get the FREE NOOK Reading App for your iPad, i... https://itunes.apple.com/us/app/nook-read-book... Y ... 4 55593 Free 4 3 3 Barnes&Noble Morgan737364737 Too old to tap Rstocky7
4 HOOKED - Chat Stories Books Keeps you on the edge of your seat. If you lov... It's a great app and I love the chills (even i... I just got through the first three parter and ... 4.54263 129 HOOKED lets you read amazing chat stories FREE... https://itunes.apple.com/us/app/hooked-chat-st... Y ... 4.5 28004 Free 4 2 4 Telepathic Inc. 100% Honest Feedback Abbidon Gangrel_Bloodfang
5 OverDrive – Library eBooks and Audiobooks Books I don't ever write reviews, but I derive utili... Love this app. With two kids, this makes findi... I listen to audiobooks from overdrive on my ph... 4.35417 48 Borrow eBooks, audiobooks, and streaming video... https://itunes.apple.com/us/app/overdrive-libr... Y ... 4 63047 Free 5 5 3 OverDrive, Inc. Blasterbob Morbidity, Revisited Ginastudysmart
6 Goodreads – Book Recommendations and Reviews Books I like tracking the books I've read. I also li... Great app for book readers. Have no complaints... I had to use goodreads in a class to keep trac... 4.51875 160 Discover and share books you love on Goodreads... https://itunes.apple.com/us/app/goodreads-book... Y ... 4.5 52969 Free 5 4 5 Goodreads, Inc Zanykfc Blueocean7 GotSomeSplaining
7 Google Play Books - Books & Comics Books This is the WORST Ereader I have ever used. I ... Updated Updated Review: The latest update has ... Google Play Books has an incredible selection;... 4.53308 1058 With Google Play Books for iOS start reading t... https://itunes.apple.com/us/app/google-play-bo... Y ... 3 11437 Free 1 1 1 Google, Inc. attyjames schoowa John Hahn
8 Scribd - Books, audiobooks, magazines, documents Books Scribd is a fairly good service (now only 3 bo... I really like this app but I just don't like t... 3.85714 7 Are you ready for access to the best books, au... https://itunes.apple.com/us/app/scribd-books-a... Y ... 4.5 11990 Free 4 4 Scribd bfchris Pata17931
9 Audiobooks Books I had it on my iPhone 2, my iPhone 4 and now m... I really really like this app and I use it all... I love this app and have used it for about 6 m... 3.55224 67 Thousands of FREE audiobooks await. Whether yo... https://itunes.apple.com/us/app/audiobooks/id3... Y ... 3 49154 Free 5 4 3 Cross Forward Consulting, LLC Ambjg 123Meier Nikravesous
10 Marvel Comics Books I've been using this app for a couple of years... A digital comic is not the same as the physica... Marvel has made an app where I can read my com... 2.64516 31 Introducing the MARVEL COMICS app, a revolutio... https://itunes.apple.com/us/app/marvel-comics/... Y ... 3.5 41114 Free 1 3 5 Marvel Entertainment Skinnydad Digital vs. Printed The coolest Aidan
11 Audio Books by Audiobooks Books And audiobooks are great for my busy lifestyle... I live on the outskirts of Los Angeles and hav... Love this app for listening to my favorite aud... 4.82 50 The hottest titles, the coolest features, and ... https://itunes.apple.com/us/app/audio-books-by... Y ... 4.5 19798 Free 5 5 5 Simply Audiobooks Inc. IssyPooh Chloececiliajonas Jkitten12
12 Tips & Tricks - Secrets for iPhone (Free Edition) Books News feeds of info about Apple products, softw... I'm always finding something new on this app. ... App looks interesting and might have some good... 3.83333 12 This is the App that should come installed on ... https://itunes.apple.com/us/app/tips-tricks-se... Y ... 3 70263 Free 4 5 1 Intelligenti Ltd Beep2014 Leese' Blue Zebram
13 The Holy Bible - King James Version Books I love this Bible app and use it daily. But wi... This Bible app is a blessing. The fact that I ... The only thing that could possibly improve the... 4.0 22 The Holy Bible - King James Version is a beaut... https://itunes.apple.com/us/app/the-holy-bible... Y ... 4.5 22095 Free 3 5 5 Tecarta, Inc. Omninico A Senior Pastor slward78
14 Kobo Reading App – Read Books Books The new update is terrible. It takes forever t... Please go back to allowing purchases directly ... interface is worse than ibooks in every way an... 3.25 8 Millions of readers love Kobo! Join them today... https://itunes.apple.com/us/app/kobo-reading-a... Y ... 3 47793 Free 1 4 2 Kobo Inc. Poor design. Jenny4OU Eopidiakiakioll1234321
15 Barnes & Noble Books I love BN with everything in me. However, here... If I wanted a web app, I'd use your mobile web... I downloaded the app today because I signed up... 1.32292 96 Put the World’s Largest Bookstore on your iPho... https://itunes.apple.com/us/app/barnes-noble/i... Y ... 3.5 40835 Free 2 1 1 Barnes&Noble SincerelyKaySea someone929292 Rochesterjeff
16 18,000 COOL JOKES FREE Books It's hard to tell whether this app is worth an... I used to love this app, then I got an update ... Jokes in this app are not that great. A lot of... 3.21429 154 World's most admired jokes app for over 4 year... https://itunes.apple.com/us/app/18-000-cool-jo... Y ... 3 87163 Free 3 1 1 Objectified Apps LLC RonG69 Quantamamalee D's Kitten
17 Free Books - Ultimate Classics Library Books First, this app has little relationship to the... Nearly all the books lack any sort of descript... After latest update they improved many things,... 2.45545 101 All books to read completely for FREE.This leg... https://itunes.apple.com/us/app/free-books-ult... Y ... 4 20353 Free 1 1 5 Digital Press Publishing, s.r.o. Sodapop04282us Autsy Newporter1406
18 Color Therapy Free Adult Coloring Book for Adults Books After reviewing the lengthy list of apps noted... For the most part I enjoy the wide variety of ... This app is fantastic. They constantly add new... 4.70906 629 Color Therapy is #1 Adult Coloring App/Book in... https://itunes.apple.com/us/app/color-therapy-... Y ... 5 82372 Free 5 4 5 Miinu Limited NotedSinger Cat'Isha ArwenEvenStar2
19 Weird But True Books Well lots of people (including me) are so disa... Personally, I love the weird but true book ser... You only get a few facts to start with. Want m... 2.48387 155 * Winner of Spring 2012 Parents’ Choice Funstu... https://itunes.apple.com/us/app/weird-but-true... Y ... 3.5 1674 Free 1 2 1 National Geographic Society Lilbudderlover PeakA&Pals Emerasd
20 Weird Facts 1000! Fun, Random, Interesting, Tr... Books I got this app probably five years ago, when I... I just got this app and I already love it!!! Y... I love reading all these facts. I came across ... 3.99301 143 Tons of cool, weird, useless, odd & awesome fu... https://itunes.apple.com/us/app/weird-facts-10... Y ... 3.5 4248 Free 5 5 5 Michael Quach chefmav Awarren79 Oopsys said...
21 DC Comics Books ******************Update*******************Thi... The reader part of this application is good en... I use the app the catch up on books that I don... 3.06897 29 DC Entertainment is one of the largest English... https://itunes.apple.com/us/app/dc-comics/id37... Y ... 3.5 11945 Free 1 2 5 DC Entertainment Drak82 Paul in NY K3vinP1
22 eBook Search - Free books for iBooks and more Books Just began using this app; so far I've been pl... I've looked for an app that lets me search mul... Easy to use, lots of books, several download f... 4.40909 88 ***** Over 4,300 5-star ratingsIf you’d like a... https://itunes.apple.com/us/app/ebook-search-f... Y ... 4.5 3029 Free 5 4 5 Inkstone Software, Inc. Tony48greenbay Galen Bradwarden Hfs furthers
23 Love Quotes and Sayings! Daily Romantic Valent... Books This app isn't a game, but it's very great if ... I've had this app for a long time, and I enjoy... You won't imagine how great this app is. There... 4.28571 35 Best Love Quotes at your fingertips!Want to in... https://itunes.apple.com/us/app/love-quotes-sa... Y ... 3 19149 Free 5 3 5 Michael Quach cmrdauer Kofo.Z Luee Jay
24 Ebook Reader Books I love that I can send a copy of my Ebook from... I tried to open a pdf file from google drive t... Does what it's supposed to do, and is friendly... 4.0 34 eBooks.com's Ebook Reader lets you read your f... https://itunes.apple.com/us/app/ebook-reader/i... Y ... 3 4635 Free 5 3 3 Ebooks.com Limited Liz_Mic HeylinEclipse mighty roxtard
25 Books - 23,469 Classics To Go. The Ultimate Eb... Books Months later, still not fixed. The developer N... My review is exactly like the first one. First... This app is as close to perfection as you can ... 2.98276 58 Like reading? Fire up our Books app and downlo... https://itunes.apple.com/us/app/books-23-469-c... Y ... 3.5 10525 Free 1 5 5 Digital Press Publishing, s.r.o. FishyFlake Hnysbny Chrisgrey39
26 Tips for iPhone - Tricks & Secrets Books If this app told me the recipe to cure cancer ... Understandably easy quick tips to help you out... This app offers some nice tips and tricks for ... 3.33929 112 ** If you are experiencing issues after updati... https://itunes.apple.com/us/app/tips-for-iphon... Y ... 4 3430 Free 2 5 5 3ight LLC Sky Blue G Phen!x Adameze
27 Hoopla Digital Books I love that my library grants access to Hoopla... I guess it's an okay compromise when you're in... I like this app overall, primarily because I d... 4.00575 522 Instantly borrow free digital movies, music, e... https://itunes.apple.com/us/app/hoopla-digital... Y ... 4 5329 Free 3 3 4 Midwest Tape LLC Real Newbie Dude0u812 River.Phoenix
28 MeeGenius Children’s Books: Storybooks + Song... Books The craters of this app are so thoughtful for ... Worked for a short period of time. Then the ap... App kept crashing but customer support was res... 3.71233 73 Nurture your child’s love for reading with thi... https://itunes.apple.com/us/app/meegenius-chil... Y ... 4 2803 Free 5 2 3 MeeGenius, Inc. Loveee rhadielys ericscottadams Deetttt
29 Manga Storm - The Ultimate Manga Reader Books If you're looking for a Manga Reader, look no ... A side note to those, complaining that you "HA... Anyone who's a fan of manga should get this ap... 4.86347 542 Looking for a nice app to *Read* and *Follow* ... https://itunes.apple.com/us/app/manga-storm-th... Y ... 4.5 18995 Free 5 5 5 Work Corner Company Limited Orcuh Somedude90 Bookster64
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
5970 KOCO 5 News First Alert Weather Weather The all-new KOCO 5 News First Alert Weather Ap... https://itunes.apple.com/us/app/koco-5-news-fi... Y ... 2.5 19 Free Hearst Television
5971 WSMV WX Weather WSMV Weather is proud to announce a full featu... https://itunes.apple.com/us/app/wsmv-wx/id6284... Y ... 2.5 50 Free WSMV Digital Media LLC
5972 WSOC-TV Channel 9 Weather App Weather Chief Meteorologist Steve Udelson and Severe W... https://itunes.apple.com/us/app/wsoc-tv-channe... Y ... 3.5 40 Free Cox Media Group, Inc
5973 NOAA Buoy and Tide Data Weather I use this app various times throughout the da... I am not sure why this app is getting some ver... The first and still the best, NOAA Buoy and Ti... https://itunes.apple.com/us/app/noaa-buoy-and-... Y ... 3.5 376 $1.99 5 4 Verona Solutions, LLC Jays Gone Fishing tmccabejr
5974 SkyTower Radar app from FOX 13 Tampa Bay Weather Get the power of FOX 13's SkyTower Radar on yo... https://itunes.apple.com/us/app/skytower-radar... Y ... 3.5 29 Free New World Communications of Tampa, Inc.
5975 NOAA Weather International Weather The app does provide the detailed forecast fro... NOAA Weather International is a wonderful app.... Super app very accurate very,very accurate on ... 4.33333 21 Retrieve real-time 7-day hyperlocal point weat... https://itunes.apple.com/us/app/noaa-weather-i... Y ... 4.5 65 Free 2 5 5 Pandamonium Software Ltd xWARSAWx Michael3129 Blue wolf 47
5976 WIS News 10 FirstAlert Weather Weather The WIS Mobile Weather App includes: * Acces... https://itunes.apple.com/us/app/wis-news-10-fi... Y ... 3.5 29 Free Raycom Media, Inc
5977 حالة الطقس Weather البرنامج جميل وبواجهة اجمل استاهل خير خل سعره 0.99 البرنامج اكثر من رائع ويستاهل 5 نجوم 4.66667 9 حالة الطقس هو أول تطبيق عربي باللغة العربية في... https://itunes.apple.com/us/app/%D8%AD%D8%A7%D... Y ... 4 148 Free 4 5 5 Mohamed Mohamed Ahmad1988sa Boabdalaziz Qamar2013
5978 9NEWS WX Weather I would've given this app five stars until I d... Complete fail in weather map past/future anima... 9News in Denver, Colorado is proud to present... https://itunes.apple.com/us/app/9news-wx/id376... Y ... 3 139 Free 1 1 Tegna Inc. Kbullfish Mermaid998
5979 Gismeteo lite Weather Справляется отлично со своей задачей, показыва... Объясните фразу: малооблачно, дождь, гроза. Не... 3.9 10 An official weather app by Gismeteo.Key featur... https://itunes.apple.com/us/app/gismeteo-lite/... Y ... 4.5 1071 Free 5 1 Roman Shmelkin iEgorovy Bax386
5980 My Tide Times - Tide Tables, Forecasts & Tides! Weather Gives times for high and low tides. Very easy ... Accurate, and useful. Great for those fishing... Living on the water in village harbor/The Cove... 4.85714 7 My Tide Times is the only tide times applicati... https://itunes.apple.com/us/app/my-tide-times-... Y ... 4.5 178 Free 5 5 4 Jake Ruston Sierra2965 ELOYHERE Downtownv
5981 Best Hunting Times Weather I love this Ap it is always very accurate, I d... Hunting times are about dead on. Except I noti... Great App. Has not been updated in a while now... 4.11111 9 The #1 solunar table app for iPhone. Monthly v... https://itunes.apple.com/us/app/best-hunting-t... Y ... 4 124 $2.99 5 4 4 K SOLUTION LLC Twoehler Comeerdeer Hunt Smart
5982 Rainly Weather I just downloaded this app when I noticed that... Huh? There is no temperature displayed. Also... this app is cute but why does it say null inst... Free for a limited time!Rainly - Rediscover th... https://itunes.apple.com/us/app/rainly/id69776... Y ... 4 143 Free 1 1 4 Paul Gibbs LBSparky Real Music-Not Rap asapmalik
5983 KCRG-TV9 First Alert Weather Weather The KCRG Mobile Weather App includes: * Acce... https://itunes.apple.com/us/app/kcrg-tv9-first... Y ... 3.5 37 Free Gazette Communications
5984 Lunar Calendar & Biorhythm - The Moon Planner Weather It's alright. I liked it till I had to update ... Just the free version shows good graphs. Don't... Need to be able to add another subject. Overal... 4.09999 10 From AustraliaTop app - by HeavensppA+++From B... https://itunes.apple.com/us/app/lunar-calendar... Y ... 3.5 492 Free 2 4 4 Morftec d.o.o. Phoenix R. Smith Ozhma trkral364
5985 WKRN WX - News 2 StormTracker Nashville weather Weather 9/10 times I open the app I'm stuck with a "fe... Never let the weather catch you by surprise ag... https://itunes.apple.com/us/app/wkrn-wx-news-2... Y ... 3 32 Free 1 LIN Television Corporation Reallyjosh
5986 Fox8 Max Weather Weather The WGHP Mobile Weather App includes: * Acce... https://itunes.apple.com/us/app/fox8-max-weath... Y ... 3 45 Free TRIBUNE BROADCASTING COMPANY INC
5987 WTOC First Alert Radar Weather The WTOC Mobile Weather App includes: * Acce... https://itunes.apple.com/us/app/wtoc-first-ale... Y ... 3.5 38 Free Raycom Media, Inc
5988 天气预报 Weather Great! good 5.0 13 天气预报:出行必备利器!提供优质的气象预报服务!全球亿万用户的共同选择! * 长达10日的... https://itunes.apple.com/us/app/%E5%A4%A9%E6%B... Y ... 4 515 Free 5 5 Aotesiqi LLC 枫咏王 iyumen
5989 天气通 - 关注天气,开启美好生活 Weather 最专业最贴心的天气APP,3.8亿用户的选择,采用权威多数据源授权信息,智能纠错,国内300... https://itunes.apple.com/us/app/%E5%A4%A9%E6%B... Y ... 4.5 1744 Free SINA Corporation (Nasdaq: SINA)
5990 WNEP Stormtracker 16 - Scranton Weather Weather The WNEP Mobile Weather App includes: • Acce... https://itunes.apple.com/us/app/wnep-stormtrac... Y ... 3 107 Free TRIBUNE BROADCASTING COMPANY INC
5991 Rain Alarm - Radar & Push Weather Don't get caught in the rain!Fed up with incor... https://itunes.apple.com/us/app/rain-alarm-rad... Y ... 4 73 Free Carlos Aviles
5992 KAIT Region 8 Weather Weather The KAIT Mobile Weather App includes: * Acce... https://itunes.apple.com/us/app/kait-region-8-... Y ... 3.5 70 Free Raycom Media, Inc
5993 منبه الطقس Weather يقوم تطبيق منبه الطقس بتنبيهك يوميا بالحاله ال... https://itunes.apple.com/us/app/%D9%85%D9%86%D... Y ... 4 10 Free Raja' Ibrahim
5994 ATsWeatherToGo Weather After moving to OK from Cali where I never pai... AT's Weather is quick but mostly it's reliable... Best weather App out there! I've tried many w... 4.19998 5 6 Reasons why you should try the ‘ATsWeatherTo... https://itunes.apple.com/us/app/atsweathertogo... Y ... 5 613 Free 5 5 5 Aaron Tuttle Mrskaylawilliams Dip crap IASAI
5995 Weather Mate - Forecast, Radar, Maps, Alerts Weather This is an unbelievably comprehensive yet extr... Multiple tornadoes have been confirmed in my l... There is times that my work requires me to tra... 4.41667 24 Say Hello to your new Mate - Weather Mate. The... https://itunes.apple.com/us/app/weather-mate-f... Y ... 4.5 350 Free 5 5 5 DylogicApps Pvt Ltd Daveber0002 BabyMan83 HorseshoerDan
5996 Your Weather Authority for South Texas - KSAT 12 Weather The KSAT Weather app brings you the latest wea... https://itunes.apple.com/us/app/your-weather-a... Y ... 2.5 26 Free Graham Media Group, Inc
5997 WeatherWheel Weather I love this app. It has a beautiful interface ... Spin the wheel and watch the weather changing ... https://itunes.apple.com/us/app/weatherwheel/i... Y ... 3.5 71 Free 5 Lukas Boehler Don't Buy 0
5998 EPA's SunWise UV Index Weather This is a good UV index app however there cert... This app displays the current UV forecast for ... I originally had a problem with this app not w... 3.0 20 The UV Index provides a daily and hourly forec... https://itunes.apple.com/us/app/epas-sunwise-u... Y ... 3.5 47 Free 4 4 4 Environmental Protection Agency jman13! I_cycle DMIA
5999 My Aurora Forecast - Northern Lights & Borealis Weather Can't thank this app and the dev's enough. I n... Using the KP and the cloud coverage, we were a... Very nice app, with notification of high proba... 4.9 10 My Aurora Forecast is the best app for seeing ... https://itunes.apple.com/us/app/my-aurora-fore... Y ... 5 107 Free 5 5 5 Jake Ruston PlayaHermosa tomtkao Aoumvin

5894 rows × 22 columns


In [108]:
app['overall reviews'] = map(lambda x: int(x) if x!='' else np.nan, app['overall reviews'])
app['overall rating'] = map(lambda x: float(x) if x!='' else np.nan, app['overall rating'])
app['current rating'] = map(lambda x: float(x) if x!='' else np.nan, app['current rating'])

Question 2 (1) What are the distributions of ratings/number of reviews across categories?


In [109]:
categories = app['category'].unique()
categories


Out[109]:
array([u'Books', u'Business', u'Catalogs', u'Education', u'Entertainment',
       u'Finance', u'Food & Drink', u'Games', u'Health & Fitness',
       u'Lifestyle', u'News', u'Travel', u'Sports', u'Music',
       u'Photo & Video', u'Magazines & Newspapers', u'Reference',
       u'Medical', u'Navigation', u'Productivity', u'Shopping',
       u'Social Networking', u'Weather', u'Utilities'], dtype=object)

In [110]:
app['category'].value_counts()


Out[110]:
Games                     380
Lifestyle                 327
Entertainment             271
News                      264
Health & Fitness          258
Photo & Video             252
Sports                    252
Food & Drink              250
Education                 248
Business                  248
Music                     246
Travel                    245
Books                     244
Social Networking         242
Shopping                  242
Medical                   241
Productivity              241
Reference                 241
Catalogs                  240
Finance                   240
Weather                   240
Utilities                 240
Navigation                240
Magazines & Newspapers      2
Name: category, dtype: int64

I make a frequency table for the number of apps in each category, and I find that the numbers of apps among different categories are not the same. This is because in category called 'Magazine&Newspaper', there are many apps that belong to other categories.


In [111]:
num_review_by_category = app.groupby(by = ['category'])['overall reviews'].sum()
num_review_by_category = pd.DataFrame(num_review_by_category)
num_review_by_category.reset_index(level = 0, inplace = True)
num_review_by_category


Out[111]:
category overall reviews
0 Books 1711180.0
1 Business 1442797.0
2 Catalogs 317635.0
3 Education 1567236.0
4 Entertainment 7899851.0
5 Finance 1692287.0
6 Food & Drink 2065692.0
7 Games 43628244.0
8 Health & Fitness 3454566.0
9 Lifestyle 2551763.0
10 Magazines & Newspapers 89.0
11 Medical 596871.0
12 Music 5484002.0
13 Navigation 1045541.0
14 News 2762681.0
15 Photo & Video 6816499.0
16 Productivity 3388168.0
17 Reference 2741107.0
18 Shopping 3107583.0
19 Social Networking 10170253.0
20 Sports 1953415.0
21 Travel 1798710.0
22 Utilities 5975284.0
23 Weather 1888014.0

In [112]:
from matplotlib import font_manager as fm
from matplotlib import cm
cs = cm.Set1(np.arange(25)/25.)
patches, texts, autotexts = plt.pie(num_review_by_category['overall reviews'], labels = num_review_by_category['category'], explode = np.repeat(0.1,24), colors = cs, autopct = '%1.1f%%', startangle = 140)
proptease = fm.FontProperties()
proptease.set_size(6)
plt.setp(texts, fontproperties=proptease)
plt.setp(autotexts, fontproperties=proptease)
plt.show()


I calculate the sum of review numbers for all apps by different catefories and I get a pie chart for it. From the plot we can see that Games have the highest number of reviews, Social Networking and Entertainment also have high number of reviews while Weather, Books, Business, Catalogs, Education, Medical, Navigation and Magazines&Newspapers Lifestyle have lower number of reviews. It seems that we can conclude that Games apps are very popular among customers while Navigation apps are not very popular among customers. We cannot say that Magazines&Newspapers apps are the least popular since it has only 2 apps in our dataset.


In [113]:
for i in range(0, len(categories)):
    app_category = app.loc[app['category'] == categories[i]]
    app_category['overall reviews'].plot(kind = "hist", bins = 5)
    plt.xlabel('Number of Reviews')
    plt.title('Distribution of number of reviews in category %s'%(categories[i]))
    plt.show()


In this step, I plot histograms of review numbers for different app categories and see the distribution of review numbers. From the plots we can see that in app category Catalogs, number of reviews for each app concentrate between 0 and 10000, in app category Education, number of reviews for each app concentrate between 0 and 20000, in app categories News, Books, Business, Finance, Food&Drink, Life Style, Sports and Productivity, number of reviews for each app concentrate between 0 and 50000, in app categories Entertainment, Health&Fitness, Weather, Utilities, Music, Navigation, Shopping and Reference, number of reviews for each app concentrate between 0 and 200000, in app categories Games, Photos&Videos and Social Networking, number of reviews for each app concentrate between 0 and 500000. As a result, we find that the ranges of review numbers in different categories are not in the same scale, maybe we need to do the following analysis by category.


In [114]:
for i in range(0, len(categories)):
    app_category = app.loc[app['category'] == categories[i]]
    app_category['overall rating'].plot(kind = "hist", bins = 5)
    plt.xlabel('Overall Rating')
    plt.title('Distribution of overall rating in category %s'%(categories[i]))
    plt.show()


In this step, I made histograms for overall rating for different categories to see the distribution of overall rating for each app in different categories. From the plots we can see that app categories Book, Business, Entertainment and News have most ratings between 3 and 3.5, app categories Life Style, Sports, Catalogs and Fodd&Drink have most ratings between 3.5 and 4, and the other app categories have most ratings between 4.5 and 5. As a result, we can find that apps in most categories have a relative high overall rating and maybe the reason for low rating in app categories Book, Business and News is the bad typesetting for articles.


In [ ]: